select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Snow White Multi-color Beaded Sweetheart Quinceneara Dresses with Ruffles
Noble Strapless Burgundy Sweet Sixteen Dresses with Pick-ups
Beaded Sweetheart Tiered Ruffles Organza Sweet Sixteen Dresses
Sweetheart Aqua Blue Layered Taffeta and Organza Quince dresses
Colorful Printing and Ruffled Organza Quinceanera Dresses
Multi-color Strapless Quinceanera Dresses with Tiered Ruffles
Ball Gown Quinceanera Dresses with Layered Ruffles and Appliques
Blue Sweetheart Ball Gown Sweet Sixteen Dresses with Ruffles
Aqua Blue Ball Gown Taffeta Pick-ups Quinceanera Gown Dresses
Mint Sweetheart Organza Beading Quinceanera Dresses with Appliques
Royal Blue Embroidery Appliqued Quinceanera Dresses with Pick-ups
Hunter Halter Top Beading Appliqued Quinceanera Dresses with Pick-ups
Classic Purple Strapless Dresses for a Quince with Appliques
Royal Blue Lace up Back Dresses for a Quince with Capelet and Pick-ups
Flower Accent Waist Baby Pink Multi-Layered Dresses for a Quince
Spring Green Organza Ball Gown Dresses for 15 with Appliques
Simple Ball Gown Strapless Appliques Quinceanera Dresses in Taffeta
Pretty Ball Gown Beading Quinceanera Dresses with Ruffled Layers
White Ball Gown Sweetheart Dresses for Sweet 15 with Embroidery
Elegant Lilac Ball Gown Straps Sweet 15 Dresses with Pick-ups
Orange Ball Gown Appliques Quinces Dresses in Taffeta and Organza
Colorful Zebra Print Appliques Vestidos De Quinceanera with Ruffles
Newest Embroidery Olive Green Trajes De Quinceanera with Pick-ups
Aqua Blue Tulle and Taffeta Beaded Quinceanera Dress with Appliques
Best Orange Ruffled Layers Strapless Quinceanera Gown with Beading
Multi-layer Organza Rose Pink Vestidos Para Quinceanera with Ruffles
Pink and White Pick-ups Sweet 15 Dresses with Hand Made Flowers
Colorful Taffeta and Organza Quince Dress with Pick-ups and Ruffles
Sequins Beading Dress for Sweet 15 with Multi-color Ruffled Layers
Enshrinement Multi-tiered Beading and Sequins Quinceanera Dress in Orange